Overview:

Elevate your Excel prowess with this training. Aimed at users already versed in Excel's core functions (SUM, X/VLOOKUP, COUNTIF etc), this course introduces users to some of the new innovative functions added since 2020, exclusively available to Microsoft 365, Excel 2021 and Excel 2024 users.

These cutting-edge tools are designed to streamline your formula creation process, enhance your data interaction, and expand your analytical capabilities. Embrace the simplicity of extracting unique values, sorting and filtering datasets, creating dynamic, self-updating lists and much more!

Whether you’re looking to improve efficiency, accuracy, or both, these features will set you on a path to becoming an Excel ninja. Ensure your skill set remains at the forefront of technological advancements with these essential, transformative functions that redefine what's possible in Excel.

Areas Covered in the Session:

• UNIQUE: Extract Distinct Values with Ease. Tired of dealing with duplicate data in your Excel sheets? With the UNIQUE function, you can effortlessly extract distinct values from your datasets. Say goodbye to manual filtering and data cleaning, and hello to a more efficient way of handling your information
• FILTER: The FILTER function empowers you to refine your data with precision, allowing you to quickly and accurately extract specific subsets of information from your datasets, saving you valuable time and ensuring your analysis is based on the most relevant data
• SEQUENCE: Automatic Ordered Lists. Creating ordered lists can be a tedious task, but not anymore. SEQUENCE enables you to generate ordered lists automatically, saving you valuable time. Whether it's dates, numbers, or any custom sequence, you'll master the art of list creation effortlessly
• SORT & SORTBY: Effortless Data Arrangement. Data arrangement doesn't have to be a hassle. With SORT and SORTBY functions, you'll discover the easiest way to sort your data. Whether it's numbers, dates, or custom criteria, we'll show you how to arrange your information like a pro
• CHOOSECOLS & CHOOSEROWS: Sometimes, you need to work with specific data segments. CHOOSECOLS and CHOOSEROWS functions empower you to do just that. Learn how to select columns or rows based on your criteria, streamlining your data analysis process
• TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Text Data Mastery. Text data manipulation is a breeze with TEXTSPLIT, TEXTBEFORE, and TEXTAFTER functions. Whether you need to split text into separate elements or extract specific parts of a text string, you'll gain the skills to handle text data like never before
• VSTACK: Seamless Array Merging. When you need to merge arrays vertically, VSTACK is your go-to function. Discover how to combine data from different sources or consolidate information effortlessly. With VSTACK, you'll achieve data integration without the headaches

Who Will Benefit:

• IMPORTANT: This intermediate-level training is tailored for Excel users eager to learn the cutting-edge functions exclusive to Microsoft 365 subscribers, Excel 2021 and Excel 2024 users. Prior to attending, confirm with your IT department whether your version of Excel includes these features